SELECT 
		bb_content.* 
		FROM bb_content LEFT JOIN bb_content_categories_link ON bb_content._id = bb_content_categories_link.contentISbb_contentID LEFT JOIN bb_content_categories ON bb_content_categories_link.categoryISbb_content_categoriesID = bb_content_categories._id 
		WHERE bb_content._deleted != 1 AND bb_content_categories.archivedYN != 1 AND bb_content.archivedYN != 1  AND (bb_content._id=30188″>The Witness]
You can read more at the link.